﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.Calendar
{
    public partial class CalendarInfo
    {
        public const string INSERT_SQL = "insert into [Calendar] ( [ID], [Name], [TypeCode], [Content], [StartTime], [EndTime], [InputTime], [CreatorID], [CreatorName], [JoinerNames], [Addr], [OtherJoiner]) values ( @ID, @Name, @TypeCode, @Content, @StartTime, @EndTime, @InputTime, @CreatorID, @CreatorName, @JoinerNames, @Addr, @OtherJoiner)";
        public const string UPDATE_SQL = "update [Calendar] set  [ID] = @ID, [Name] = @Name, [TypeCode] = @TypeCode, [Content] = @Content, [StartTime] = @StartTime, [EndTime] = @EndTime, [InputTime] = @InputTime, [CreatorID] = @CreatorID, [CreatorName] = @CreatorName, [JoinerNames] = @JoinerNames, [Addr] = @Addr, [OtherJoiner] = @OtherJoiner where ID = @ID";
        public CalendarInfo() 
        {
            lstJoinerUserIDs = new List<int>();
            lstJoinerDeptIDs = new List<int>();
        }
        public Int32 ID
        {
            get;
            set;
        }
        public String Name
        {
            get;
            set;
        }
        public Int32 TypeCode
        {
            get;
            set;
        }
        public String Content
        {
            get;
            set;
        }
        public DateTime StartTime
        {
            get;
            set;
        }
        public DateTime EndTime
        {
            get;
            set;
        }
        public DateTime InputTime
        {
            get;
            set;
        }
        public Int32 CreatorID
        {
            get;
            set;
        }
        public String CreatorName
        {
            get;
            set;
        }
        public String JoinerNames
        {
            get;
            set;
        }
        public String Addr
        {
            get;
            set;
        }
        public String OtherJoiner
        {
            get;
            set;
        }

        private List<int> lstJoinerDeptIDs;
        private List<int> lstJoinerUserIDs;
        public List<int> JoinerDeptIDs
        {
            get
            {
                return lstJoinerDeptIDs;
            }
            set
            {
                lstJoinerDeptIDs = value;
            }
        }
        public List<int> JoinerUserIDs
        {
            get
            {
                return lstJoinerUserIDs;
            }
            set
            {
                lstJoinerUserIDs = value;
            }
        }

       

    }


}
